<?php
class communication_tpl_1 extends Update_Model_Database_AbstractChange{


	protected $comment="Создание таблицы communication_tpl";

	public function up(){
		$sql=
			'CREATE TABLE IF NOT EXISTS communication_tpl(
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `alias` varchar(300) NOT NULL,
			  `lan` varchar(255) DEFAULT NULL,
			  `text` text NOT NULL,
			  `description` text,
			  `header` text,
			  PRIMARY KEY (`id`)
			)
				ENGINE = INNODB
				CHARACTER SET utf8
				COLLATE utf8_general_ci;';
		$this->db->query($sql);
	}

	public function down(){
		$sql='DROP TABLE IF EXISTS communication_tpl ;';
		$this->db->query($sql);
	}

}